{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["MSU","MYP, MSS","Kärkilyönnit"],"read":"whole","date_system":"1900"}

{"sheet":"MSU","index":0,"n_rows":28,"n_cols":43,"rows_kept":28}
[null,"Teemu Hollanti",null,null,"24.9.2002   Kannus"]
[null,"SUPERPESIS",null,null,"Runkosarja",{"$nulls":3},"  Kärkilyönnit (KL),  pesänvälit",{"$nulls":6},"      Runkosarja TOP-30",{"$nulls":4},"Ylempi loppusarja",{"$nulls":6},"Ylempi loppusarja TOP-10",{"$nulls":4},"Play off, voitot, voittoprosentti",{"$nulls":4}," Arvo-ottelut",null,null,"      Mitalit"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","0 > 1","1 > 2","2 > 3","3 > k","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"Puolivälierät","Välierät","Pronssi","Finaalit",null,"IL","LL","hSM","K","H","P"]
[null,2017,"7.","Ura  2",null,"suomensarja"]
[null,2018,"13.","YK",null,"B-poikien SM-sarja"]
[null,2019,"7.","Ura",null,"suomensarja"]
[null,2019,"12.","Ura",null,"ykköspesis"]
[null,2020,"7.","Ura",null,"suomensarja"]
[null,2020,"8.","Ura",null,"ykköspesis"]
[null,2021,"7.","Ura",null,"suomensarja"]
[null,2021,"4.","Ura",null,"ykköspesis"]
[null,2022,"7.","Ura",null,"suomensarja"]
[null,2022,"9.","Ura",null,"ykköspesis"]
[null,2023,6,"Ura",null,"ykköspesis"]
[null,2023,"3.","KeKi",10,0,0,7,27,24,3,0,0,{"v":0.6585365853658537,"d":"65.9 %"},41,{"$nulls":5},14,1,1,15,34,{"v":0.5861999999999999,"d":"58.6 %"},58,null,"6.",{"$nulls":3},"4-3  JoMa","1-3  SoJy","2-1  Manse PP",{"$nulls":7},1]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E15)","v":10},0,0,7,27,24,3,0,0,{"$f":"PRODUCT(I16/O16)","v":{"v":0.6585365853658537,"d":"65.9 %"}},{"$f":"SUM(O4:O15)","v":41},"0-0-0","0-0-0","0-0-0","0-0-0",null,{"$f":"SUM(U4:U15)","v":14},{"$f":"SUM(V4:V15)","v":1},{"$f":"SUM(W4:W15)","v":1},{"$f":"SUM(X4:X15)","v":15},{"$f":"SUM(Y4:Y15)","v":34},{"$f":"PRODUCT(N22)","v":{"v":0.5862068965517241,"d":"58.6 %"}},null,"0-0-0","0-0-0","0-0-0","0-0-0",null,"1/1","0/1","1/1","0/0",null,{"$f":"SUM(AL4:AL15)","v":0},0,0,0,0,1]
[{"$nulls":32},{"v":1,"d":"100.0 %"},{"v":0,"d":"0.0 %"},{"v":1,"d":"100.0 %"},{"v":0,"d":"0.0 %"}]
[null,"Pesispörssi",null,{"$f":"SUM(F16:H16)+((I16-F16-G16)/3)+(E16/3)+(AL16*25)+(AM16*25)+(AN16*10)+(AO16*25)+(AP16*20)+(AQ16*15)-15","v":{"v":19.33333333333333,"d":"19.3"}}]
[]
[null,"URA SUPERISSA",null,null,"OTT","KUN","LÖI","TOI","KL",null,"ka/L","ka/T","ka/KL","KL-%",null,"ENSIMMÄISET RUNKOSARJASSA",{"$nulls":16},"ENSIMMÄISET PUDOTUSPELEISSÄ",{"$nulls":4},"YLEISÖ"]
[null,"Runkosarja",null,null,{"$f":"PRODUCT(E16)","v":10},{"$f":"PRODUCT(F16)","v":0},{"$f":"PRODUCT(G16)","v":0},{"$f":"PRODUCT(H16)","v":7},{"$f":"PRODUCT(I16)","v":27},null,{"$f":"PRODUCT((F21+G21)/E21)","v":{"v":0,"d":"0.00"}},{"$f":"PRODUCT(H21/E21)","v":{"v":0.7,"d":"0.70"}},{"$f":"PRODUCT(I21/E21)","v":{"v":2.7,"d":"2.70"}},{"$f":"PRODUCT(N16)","v":{"v":0.6585365853658537,"d":"65.9 %"}},{"$f":"PRODUCT(O16)","v":41},"Ottelu",null,"15.05. 2023  KoU - KeKi  0-2  (0-3, 1-8)",{"$nulls":7},"1.  ottelu",null,null,"  20 v   7 kk 21 pv",{"$nulls":3},"Ottelu","1.   18.08. 2023  JoMa - KeKi  1-2",{"$nulls":3},1631,null,"20 v 10 kk 25 pv"]
[null,"Ylempi loppusarja",null,null,{"$f":"PRODUCT(U16)","v":14},{"$f":"PRODUCT(V16)","v":1},1,15,34,null,{"$f":"PRODUCT((F22+G22)/E22)","v":{"v":0.14285714285714285,"d":"0.14"}},{"$f":"PRODUCT(H22/E22)","v":{"v":1.0714285714285714,"d":"1.07"}},{"$f":"PRODUCT(I22/E22)","v":{"v":2.4285714285714284,"d":"2.43"}},{"$f":"PRODUCT(I22/O22)","v":{"v":0.5862068965517241,"d":"58.6 %"}},58,"Lyöty",{"$nulls":16},"Lyöty","3.   20.08. 2023  KeKi - JoMa  2-0",{"$nulls":3},2023,null,"20 v 10 kk 27 pv"]
[null,"Alempi loppusarja",{"$nulls":13},"Tuotu",null,"15.05. 2023  KoU - KeKi  0-2  (0-3, 1-8)",{"$nulls":7},"1.  ottelu",null,null,"  20 v   7 kk 21 pv",{"$nulls":3},"Tuotu","3.   20.08. 2023  KeKi - JoMa  2-0",{"$nulls":3},2023,null,"20 v 10 kk 27 pv"]
[null,"KAIKKI",null,null,{"$f":"SUM(E21:E23)","v":24},{"$f":"SUM(F21:F23)","v":1},{"$f":"SUM(G21:G23)","v":1},{"$f":"SUM(H21:H23)","v":22},{"$f":"SUM(I21:I23)","v":61},null,{"$f":"PRODUCT((F24+G24)/E24)","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"PRODUCT(H24/E24)","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"PRODUCT(I24/E24)","v":{"v":2.5416666666666665,"d":"2.54"}},{"$f":"PRODUCT(I24/O24)","v":{"v":0.6161616161616161,"d":"61.6 %"}},{"$f":"SUM(O21:O23)","v":99},"Kunnari",{"$nulls":16},"Kunnari","3.   20.08. 2023  KeKi - JoMa  2-0",{"$nulls":3},2023,null,"20 v 10 kk 27 pv"]
[{"$nulls":14},{"$f":"SUM(O22:O24)","v":157}]
[null,"Seurat",null,"Ura = Kannuksen Ura  (1969),  kasvattajaseura"]
[{"$nulls":3},"YK = Ylivieskan Kuula  (1909)"]
[{"$nulls":3},"KeKi = Kempeleen Kiri  (1915)"]

{"sheet":"MYP, MSS","index":1,"n_rows":17,"n_cols":45,"rows_kept":17}
[null,"Teemu Hollanti",null,null,"24.9.2002   Kannus"]
[null,"YKKÖSPESIS",null,null,"Runkosarja",{"$nulls":6},"    Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat",{"$nulls":6},"SUOMENSARJA",null,null,"Runkosarja",{"$nulls":6},"  Runkosarja TOP-10",{"$nulls":4},"Jatkosarjat"]
[null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"Vuosi","Sija","Seura","OTT","KUN","LÖI","TOI","KL","KL-%",null,"LÖI","TOI","L+T","KL",null,"OTT","KUN","LÖI","TOI","KL","KL-%"]
[{"$nulls":23},2017,"7.","Ura  2",3,0,0,0,2,{"v":1,"d":"100.0 %"},2]
[null,2018,"13.","YK",null,"B-poikien SM-sarja"]
[null,2019,"12.","Ura",1,0,0,0,2,{"v":0.6666,"d":"66.7 %"},3,{"$nulls":12},2019,"7.","Ura",11,0,1,8,30,{"v":0.5172,"d":"51.7 %"},58]
[null,2020,"8.","Ura",5,0,0,6,15,{"v":0.5,"d":"50.0 %"},30,{"$nulls":12},2020,"7.","Ura  2",7,0,0,12,29,{"v":0.6041,"d":"60.4 %"},48]
[null,2021,"4.","Ura",19,0,0,15,65,{"v":0.6373,"d":"63.7 %"},102,{"$nulls":5},2,0,1,0,6,{"v":0.5,"d":"50.0 %"},12,2021,"7.","Ura  2",12,2,9,36,75,{"v":0.6818,"d":"68.2 %"},110,null,"4.","6."]
[null,2022,"9.","Ura",21,0,1,21,109,{"v":0.7171,"d":"71.7 %"},152,{"$nulls":3},"10.",null,4,0,0,2,10,{"v":0.5556,"d":"55.6 %"},18,2022,"7.","Ura  2",1,0,0,0,1,{"v":0.1667,"d":"16.7 %"},6]
[null,2023,"6.","Ura",19,2,4,22,102,{"v":0.7182999999999999,"d":"71.8 %"},142]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E4:E10)","v":65},{"$f":"SUM(F4:F10)","v":2},{"$f":"SUM(G4:G10)","v":5},{"$f":"SUM(H4:H10)","v":64},{"$f":"SUM(I4:I10)","v":293},{"$f":"PRODUCT(I11/K11)","v":{"v":0.682983682983683,"d":"68.3 %"}},{"$f":"SUM(K4:K10)","v":429},{"$nulls":5},{"$f":"SUM(Q4:Q10)","v":6},{"$f":"SUM(R4:R10)","v":0},{"$f":"SUM(S4:S10)","v":1},{"$f":"SUM(T4:T10)","v":2},{"$f":"SUM(U4:U10)","v":16},{"$f":"PRODUCT(U11/W11)","v":{"v":0.5333333333333333,"d":"53.3 %"}},{"$f":"SUM(W4:W10)","v":30},"YHTEENSÄ",null,null,{"$f":"SUM(AA4:AA10)","v":34},{"$f":"SUM(AB4:AB10)","v":2},{"$f":"SUM(AC4:AC10)","v":10},{"$f":"SUM(AD4:AD10)","v":56},{"$f":"SUM(AE4:AE10)","v":137},{"$f":"PRODUCT(AE11/AG11)","v":{"v":0.6116071428571429,"d":"61.2 %"}},{"$f":"SUM(AG4:AG10)","v":224},{"$nulls":5},{"$f":"SUM(AM4:AM10)","v":0},{"$f":"SUM(AN4:AN10)","v":0},{"$f":"SUM(AO4:AO10)","v":0},{"$f":"SUM(AP4:AP10)","v":0},{"$f":"SUM(AQ4:AQ10)","v":0},{"v":0,"d":"0.0 %"},{"$f":"SUM(AS4:AS10)","v":0}]
[]
[null,"KAIKKI OTTELUT",null,null,"OTT","KUN","LÖI","TOI","KL","KL-%",null,"ka/L","ka/T","ka/l+t","ka/kl",null,null,"Seurat",null,"Ura = Kannuksen Ura  (1969),  kasvattajaseura"]
[null,"SUPERPESIS",null,null,24,1,1,22,61,{"v":0.616,"d":"61.6 %"},{"$f":"PRODUCT(I14/J14)","v":99.02597402597402},{"$f":"PRODUCT((F14+G14)/E14)","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"PRODUCT(H14/E14)","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"PRODUCT((F14+G14+H14)/E14)","v":{"v":1,"d":"1.00"}},{"$f":"PRODUCT(I14/E14)","v":{"v":2.5416666666666665,"d":"2.54"}},{"$nulls":4},"YK = Ylivieskan Kuula  (1909)"]
[null,"YKKÖSPESIS",null,null,{"$f":"PRODUCT(E11+Q11)","v":71},{"$f":"PRODUCT(F11+R11)","v":2},{"$f":"PRODUCT(G11+S11)","v":6},{"$f":"PRODUCT(H11+T11)","v":66},{"$f":"PRODUCT(I11+U11)","v":309},{"$f":"PRODUCT(I15/K15)","v":{"v":0.673202614379085,"d":"67.3 %"}},{"$f":"PRODUCT(K11+W11)","v":459},{"$f":"PRODUCT((F15+G15)/E15)","v":{"v":0.11267605633802817,"d":"0.11"}},{"$f":"PRODUCT(H15/E15)","v":{"v":0.9295774647887324,"d":"0.93"}},{"$f":"PRODUCT((F15+G15+H15)/E15)","v":{"v":1.0422535211267605,"d":"1.04"}},{"$f":"PRODUCT(I15/E15)","v":{"v":4.352112676056338,"d":"4.35"}},{"$nulls":4},"KeKi = Kempeleen Kiri  (1915)"]
[null,"SUOMENSARJA",null,null,{"$f":"PRODUCT(AA11+AM11)","v":34},{"$f":"PRODUCT(AB11+AN11)","v":2},{"$f":"PRODUCT(AC11+AO11)","v":10},{"$f":"PRODUCT(AD11+AP11)","v":56},{"$f":"PRODUCT(AE11+AQ11)","v":137},{"$f":"PRODUCT(I16/K16)","v":{"v":0.6116071428571429,"d":"61.2 %"}},{"$f":"PRODUCT(AG11+AS11)","v":224},{"$f":"PRODUCT((F16+G16)/E16)","v":{"v":0.35294117647058826,"d":"0.35"}},{"$f":"PRODUCT(H16/E16)","v":{"v":1.6470588235294117,"d":"1.65"}},{"$f":"PRODUCT((F16+G16+H16)/E16)","v":{"v":2,"d":"2.00"}},{"$f":"PRODUCT(I16/E16)","v":{"v":4.029411764705882,"d":"4.03"}}]
[null,"YHTEENSÄ",null,null,{"$f":"SUM(E14:E16)","v":129},{"$f":"SUM(F14:F16)","v":5},17,144,507,{"$f":"PRODUCT(I17/K17)","v":{"v":0.6483160621761658,"d":"64.8 %"}},{"$f":"SUM(K14:K16)","v":782.025974025974},{"$f":"PRODUCT((F17+G17)/E17)","v":{"v":0.17054263565891473,"d":"0.17"}},{"$f":"PRODUCT(H17/E17)","v":{"v":1.1162790697674418,"d":"1.12"}},{"$f":"PRODUCT((F17+G17+H17)/E17)","v":{"v":1.2868217054263567,"d":"1.29"}},{"$f":"PRODUCT(I17/E17)","v":{"v":3.9302325581395348,"d":"3.93"}}]

{"sheet":"Kärkilyönnit","index":2,"n_rows":19,"n_cols":29,"rows_kept":19}
[null,"KÄRKILYÖNNIT RUNKOSARJASSA",{"$nulls":19},"VUOSITTAISET SIJOITUKSET  TOP - 30"]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[null,"Vuosi","Sija","Seura","OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%",null,"Vuosi","Sija","Seura","0 > 1","1 > 2","2 > 3","3 > k","KL"]
[]
[null,2023,"4.","KeKi",10,24,36,{"v":0.6667,"d":"66.7 %"},3,3,{"v":1,"d":"100.0 %"},0,1,{"v":0,"d":"0.0 %"},0,1,{"v":0,"d":"0.0 %"},27,41,{"v":0.6585,"d":"65.9 %"},null,2023,"4.","KeKi"]
[null,"Yhteensä",null,null,{"$f":"SUM(E4:E5)","v":10},{"$f":"SUM(F4:F5)","v":24},{"$f":"SUM(G4:G5)","v":36},{"$f":"PRODUCT(F6/G6)","v":{"v":0.6666666666666666,"d":"66.7 %"}},{"$f":"SUM(I4:I5)","v":3},{"$f":"SUM(J4:J5)","v":3},{"$f":"PRODUCT(I6/J6)","v":{"v":1,"d":"100.0 %"}},{"$f":"SUM(L4:L5)","v":0},{"$f":"SUM(M4:M5)","v":1},{"$f":"PRODUCT(L6/M6)","v":{"v":0,"d":"0.0 %"}},{"$f":"SUM(O4:O5)","v":0},{"$f":"SUM(P4:P5)","v":1},{"$f":"PRODUCT(O6/P6)","v":{"v":0,"d":"0.0 %"}},{"$f":"SUM(R4:R5)","v":27},{"$f":"SUM(S4:S5)","v":41},{"$f":"PRODUCT(R6/S6)","v":{"v":0.6585365853658537,"d":"65.9 %"}}]
[]
[null,"KÄRKILYÖNNIT YLEMMISSÄ PUDOTUSPELEISSÄ",{"$nulls":19},"VUOSITTAISET SIJOITUKSET  TOP - 30"]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[null,"Vuosi","Sija","Seura","OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%",null,"Vuosi","Sija","Seura","0 > 1","1 > 2","2 > 3","3 > k","KL"]
[]
[null,2023,"3.","KeKi",14,28,52,{"v":0.5385,"d":"53.9 %"},2,2,{"v":1,"d":"100.0 %"},2,2,{"v":1,"d":"100.0 %"},2,2,{"v":1,"d":"100.0 %"},34,58,{"v":0.5861999999999999,"d":"58.6 %"},null,2023,"3.","KeKi","7.",{"$nulls":3},"30."]
[null,"Yhteensä",null,null,{"$f":"SUM(E9:E12)","v":14},{"$f":"SUM(F11:F12)","v":28},{"$f":"SUM(G11:G12)","v":52},{"$f":"PRODUCT(F13/G13)","v":{"v":0.5384615384615384,"d":"53.8 %"}},{"$f":"SUM(I11:I12)","v":2},{"$f":"SUM(J11:J12)","v":2},{"$f":"PRODUCT(I13/J13)","v":{"v":1,"d":"100.0 %"}},{"$f":"SUM(L11:L12)","v":2},{"$f":"SUM(M11:M12)","v":2},{"$f":"PRODUCT(L13/M13)","v":{"v":1,"d":"100.0 %"}},{"$f":"SUM(O11:O12)","v":2},{"$f":"SUM(P11:P12)","v":2},{"$f":"PRODUCT(O13/P13)","v":{"v":1,"d":"100.0 %"}},{"$f":"SUM(R11:R12)","v":34},{"$f":"SUM(S11:S12)","v":58},{"$f":"PRODUCT(R13/S13)","v":{"v":0.5862068965517241,"d":"58.6 %"}}]
[]
[null,"KÄRKILYÖNNIT "]
[{"$nulls":6},"0 > 1",null,null,"1 > 2",null,null,"2 > 3",null,null,"3 > k",null,null,"Yhteensä"]
[{"$nulls":4},"OTT","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%","KL","YHT","%"]
[null,"RUNKOSARJA",null,null,{"$f":"PRODUCT(E6)","v":10},24,36,{"v":0.6666666666666666,"d":"66.7 %"},3,3,{"v":1,"d":"100.0 %"},0,1,{"v":0,"d":"0.0 %"},0,1,{"v":0,"d":"0.0 %"},27,41,{"v":0.6585365853658537,"d":"65.9 %"}]
[null,"PLAY OFF",null,null,{"$f":"PRODUCT(E13)","v":14},{"$f":"PRODUCT(F13)","v":28},52,{"v":0.5384615384615384,"d":"53.8 %"},2,2,{"v":1,"d":"100.0 %"},2,2,{"v":1,"d":"100.0 %"},2,2,{"v":1,"d":"100.0 %"},34,58,{"v":0.5862068965517241,"d":"58.6 %"}]